Creating a Database
You can create an ODBC database and use Windows’ Control Panel to open the ODBC applet and add a new database connection by following these steps:
|
Note
|
To use the new database, remember to set up the Server option in the INI file. |
- Open Windows’ Control Panel. Double-click the ODBC Data Sources icon.
- On the User DSN page (the first page), click Add. The next page that appears should have the Microsoft Access Driver selected. If not, select it and click Finish.
- On the next window, enter a name for your database in the Data Source Name field. Then click Create.
- On the File window, move to the directory where you want the database created. Enter the database file name. This does not have to be the same name as the Data Source Name. When you finish, click Ok. You should now see the database name above the buttons in the Data Source Name window. Click OK again.
Now you see the list of databases window again and your new database should appear in the list. Click Ok to close the window.
|
Note
|
For Windows 2000, first select Administrative Tools which takes you to another window that contains the ODBC Data Sources icon. |
- Edit the FSIUSER.INI for the new database. Add these lines (assuming its name is DMS1):
< DBHandler:ODBC >
Server = DMS1
The Server option defines the Data Source Name you used to name the database, not the file name of the database.
- Run the utility in the directory where your INI files reside. When it finishes, you should be able to open the database using Access to see that it is populated.
© Copyright 2013, Oracle and/or its affiliates. All rights reserved. Legal notices.
Open table of contents